package com.zkr.kfkw.mapper;

import com.zkr.kfkw.model.*;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import javax.validation.Valid;
import java.util.List;

/**
 *Created by lenovo on 2021/01/18.
 */
@Mapper
public interface KFKWMapper {
    int queryCount(KFKWSelectVo kfkwSelectVo);

    List<KFKWVo> queryPage(KFKWSelectVo kfkwSelectVo);

    void updateStatus(KFKWVo kfkwVo);



    @Select("select kqcode code,kqname name ,kid id from kuqu where warehouseId=#{id}")
    List<KQSelectVo> query(Integer id);

    @Select("select w.code,w.name,w.wid id from kuwei w where kid = #{storageSectionId}")
    List<KWVo> querykw(KWVo kwVo);

    @Select("select * from kuwei where name=#{name} ")
    KFKWVo queryByName(String name);

    @Select("select * from kuwei where code=#{code}")
    KFKWVo queryByCode(String code);

    void delete(@Valid List<KFKWAddVo> kfkwAddVoList);

    void add(@Valid List<KFKWAddVo> kfkwAddVoList);

    void update(KFKWVo kfkwVo);


    // void add(@Valid List<KFKWAddVo> kfkwAddVoList);


    //void delete(@Valid List<KFKWAddVo> kfkwAddVoList);











}
